#!/bin/bash
mysql -uroot -pmysql << EOF
insert into tb_house(title, price,address_id,address, room_count, acreage, unit, capacity,beds,deposit,min_days, max_days, user_id, index_image_url)
values("10",100,1,"10号",5,100,"两室两厅",5,"双人床",1000,1,0,4, "FsFYi6s3qOACYN3ed8glELSADtWl");

insert into tb_house(title, price,address_id,address, room_count, acreage, unit, capacity,beds,deposit,min_days, max_days, user_id, image_url)
values("10",100,2,"10号",5,100,"两室两厅",5,"双人床",1000,1,0,4, "FmkoNkaZgBAIZN2sCM46RY1ihzBD");

COMMIT;#对于更新表格的操作执行commit语句
EOF
